UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P1jEetzsAEKVu8H5obbNKpaAPyFTMn1H8MwTLoVo7as='
WHERE
key_id = '3c943a27da3e822a8f23b0a7f19460f149cb6e71d2060d33bccbb880f64f803f'
AND (
token = 'P1jEetzsAEKVu8H5obbNKpaAPyFTMn1H8MwTLoVo7as='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)