UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zPG+lspmrOBKgyFyqPTKuAifo+0rUG9LoxmkDweNhR8='
WHERE
key_id = 'eea9849214da06aa189bda93a2aba96d96726b435f0af1d64c08990f82d7f012'
AND (
token = 'zPG+lspmrOBKgyFyqPTKuAifo+0rUG9LoxmkDweNhR8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)