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