UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zogmr2qoTdYc6eaAJYe3edIG0wc5/4Psv0/OXcxkpJE='
WHERE
key_id = '5bff99584541f6e91d1b0f74148311c2fc2d52b9c7fa3a4285d565bcb6592630'
AND (
token = 'Zogmr2qoTdYc6eaAJYe3edIG0wc5/4Psv0/OXcxkpJE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)