UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XAnQnACXM1OaJXu0KygVYobXvOw+/zoHnWKlrpXmGIM='
WHERE
key_id = '1d7c38cf644c0f9d2f96bb81a954b6e1020d60eaaae493850c1d9f5fe85cc8c5'
AND (
token = 'XAnQnACXM1OaJXu0KygVYobXvOw+/zoHnWKlrpXmGIM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)