UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x0hc9tVac7GfEgVsENKdk9DOOkPLubgucWlSks5r88o='
WHERE
key_id = '089e9e9aa5c12a686fc0e692ecdce211f9b9f8ccdebbd8efe8f0e0e6b1318b8d'
AND (
token = 'x0hc9tVac7GfEgVsENKdk9DOOkPLubgucWlSks5r88o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)