UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Snnksok+zWMuib1Svh5oLpgYYVqRLfjCnM1QcoW96ug='
WHERE
key_id = 'd4ba2832d6a42e68b200508a2ba60cf744f310001d7a0c0b0da171eebb69b48e'
AND (
token = 'Snnksok+zWMuib1Svh5oLpgYYVqRLfjCnM1QcoW96ug='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)