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