UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QKHz/yw7hjXuuNAMqCMyl8e/wm/4O9f8VVpop6k4ndA='
WHERE
key_id = '47f05734900d44464f03b429e16dd7f2d0ba5bfbfcdc42f319e46d886f047baf'
AND (
token = 'QKHz/yw7hjXuuNAMqCMyl8e/wm/4O9f8VVpop6k4ndA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)