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