UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RokCPBl8rK96vS5znqIU5A84yPDXW5N33FKeg1743Kw='
WHERE
key_id = '7cd0d6fcf8606afa458fd88c2f3fbf082ea246c25de8fc6d15b5bffa62d7b729'
AND (
token = 'RokCPBl8rK96vS5znqIU5A84yPDXW5N33FKeg1743Kw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)