UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ghAnsjfsJGeUaC2K+DAy/86NWRhrQWx6naDHUyggmd0='
WHERE
key_id = 'f241b6c7e7981c1a617f844679fca525f22a22b27083c6447eacec07571afe47'
AND (
token = 'ghAnsjfsJGeUaC2K+DAy/86NWRhrQWx6naDHUyggmd0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)