UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/A0vkn2rDxP5I96C0rT6Hh7JGHu7PDcJqbZmv11n6PE='
WHERE
key_id = '8b153b13f7ef215ad8a22a8d8302128b250fe45a2e190c32d597465dacdf8a25'
AND (
token = '/A0vkn2rDxP5I96C0rT6Hh7JGHu7PDcJqbZmv11n6PE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)