UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6HtYgSjAifY0HC5FxiUS/2QqhPfIZv0sq7fk3volq7c='
WHERE
key_id = '76a1b87dee80113fc8761d7b62fcde8abaa6b406be35f6a3b1da6bf812630e29'
AND (
token = '6HtYgSjAifY0HC5FxiUS/2QqhPfIZv0sq7fk3volq7c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)