UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JZtE8rYrCuwa8OImJEIeGF6KFUfNwFAEsC6zBwfgxvg='
WHERE
key_id = '0bfeda7de170d025688513d19748971684a1611943639a2450e5686bdbbb29c5'
AND (
token = 'JZtE8rYrCuwa8OImJEIeGF6KFUfNwFAEsC6zBwfgxvg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)