UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm63pzavllJUupZXDUWKV9TcduofvpMOm00i5euwi4b0='
WHERE
key_id = 'b56cf4aceb9522ad30559201f588049a28bef8900a38b6a0df4cc9a4d8abd966'
AND (
token = 'm63pzavllJUupZXDUWKV9TcduofvpMOm00i5euwi4b0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)