UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mBsq3GEFfPb9FbzPCnmzNQHvrqy7IHARMU3Aiva0vXw='
WHERE
key_id = '8974777e4a545761835f831f0b4606e38dbf795f4674ccfa008f54614e76ddeb'
AND (
token = 'mBsq3GEFfPb9FbzPCnmzNQHvrqy7IHARMU3Aiva0vXw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)