UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L1yeYJ4vY89kPALve0gQfXovkVojPt9uBHbo649J2cc='
WHERE
key_id = '817b93de4ec217f8f2e0c30b349369f7bdf659c048e1f9e292affffcf156b4fb'
AND (
token = 'L1yeYJ4vY89kPALve0gQfXovkVojPt9uBHbo649J2cc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)