UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eK0A+3hP1hzkVm9KlxH900qrPmvatP2uv/aXaBHKMXc='
WHERE
key_id = '8bb1b8e592e07884362b3f5e979cf04aa3c4e667572d8ab0e579af5de5482de8'
AND (
token = 'eK0A+3hP1hzkVm9KlxH900qrPmvatP2uv/aXaBHKMXc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)