UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VCGkUXoUtuuR3pW3YQroOjNVnsgb4UtXh7I8rYaejLg='
WHERE
key_id = '2a2c4b9f6808533c44e8790a38fccec3129f4c858422e5ce5bb894ad8c9e3e0c'
AND (
token = 'VCGkUXoUtuuR3pW3YQroOjNVnsgb4UtXh7I8rYaejLg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)