UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2zsVklz+Tmjd0HpN7bJ0gx5DA5JUtQcH0LOarWqZN5o='
WHERE
key_id = '31bbca9127d985c286cb0b5ef18fb72ce7e49ce0ca57c02f49a50a7a7625ce36'
AND (
token = '2zsVklz+Tmjd0HpN7bJ0gx5DA5JUtQcH0LOarWqZN5o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)