UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LXySwvbyhOrdyZhlzZe5qfsHfbe8PqhcqUYnxA4JnQc='
WHERE
key_id = '4f8d47332151b67b670feb021413b33f464dee23b0091828ff21e2a61349f178'
AND (
token = 'LXySwvbyhOrdyZhlzZe5qfsHfbe8PqhcqUYnxA4JnQc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)