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