UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vnc5ZqPcBCSqSDHuMnrtyW1MzgzN4K53VPSAL5gpVSs='
WHERE
key_id = 'cf3dfca1a166fa3e9a8cdd6a05d87a5b1294efc0c16a3dfd440bb353b9aa4f5f'
AND (
token = 'Vnc5ZqPcBCSqSDHuMnrtyW1MzgzN4K53VPSAL5gpVSs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)