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