UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X/KLc4t+BCetA7RQXbqYmA4zwPssEo1wD6S9wqxv/nk='
WHERE
key_id = '4e5aa3cf33936f6f6a35115cab762c0274833794ed498c0f4ec7f4ed9d57c7e5'
AND (
token = 'X/KLc4t+BCetA7RQXbqYmA4zwPssEo1wD6S9wqxv/nk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)