UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i8EaWta970k+GOYkCW6GloQ8aEk0xn8B9RPwjaJONbY='
WHERE
key_id = 'dc4fee80c543dc4d1ae8327e584a347a72d56e0c096ea67eef9ae97b10c9b812'
AND (
token = 'i8EaWta970k+GOYkCW6GloQ8aEk0xn8B9RPwjaJONbY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)