UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b0EL54I4tdrmp6oefwB1Xzfh3j7RbYG9y6qm5ZFwmgE='
WHERE
key_id = '1cf82196d3b093b3f834e08a66a0cc0e0ac50c2eeec81bda125a527f38476ba2'
AND (
token = 'b0EL54I4tdrmp6oefwB1Xzfh3j7RbYG9y6qm5ZFwmgE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)