UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'chZxhN83Da9M2yBkSHk4WY5MzIM5N+dM1IgGIFyX5so='
WHERE
key_id = 'b7274445287e316c23682dfb85256af4319934f239ccf01ea2e1b98c98e566f1'
AND (
token = 'chZxhN83Da9M2yBkSHk4WY5MzIM5N+dM1IgGIFyX5so='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)