UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9kY2iYuRDxNC8aSU4GobDKxAWbL+yn4Dk4c40M/T864='
WHERE
key_id = 'd859d8fae2475afd72ecffbdaf1dbb53c3d14811f3537e1eddfa9288a74a365a'
AND (
token = '9kY2iYuRDxNC8aSU4GobDKxAWbL+yn4Dk4c40M/T864='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)