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