UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jre9qUm5W0SpGxCiglBXwwOuTcEUoZEai8VJypgXVN8='
WHERE
key_id = 'e535a8cbcbd8fe03ce1af3caedbb5e1201869aff358c43e47d2090a92a68125f'
AND (
token = 'jre9qUm5W0SpGxCiglBXwwOuTcEUoZEai8VJypgXVN8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)