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