UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cFd7phLRL/sPScbakdrE+Sv2QHvGsHojMw/8R/0q+X0='
WHERE
key_id = 'adbd7cef06d989077a2c2c0280e113c5fa71bdd40f8d569d6d12096108d75abb'
AND (
token = 'cFd7phLRL/sPScbakdrE+Sv2QHvGsHojMw/8R/0q+X0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)